package com.icss.clothes.mapper;

import com.icss.clothes.entity.Size;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SizeMapper {
    //通过指定的商品编号获取得到所有商品的商品型号
    @Select("select distinct s.* from size s left outer join commodity_detail cd on s.size_id=cd.size_id " +
            "where cd.c_id=#{c_id}")
    public List<Size> selectAllSizeByC_id(int c_id);
}
